﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;

namespace DoAnQuamLy.DataAccess
{
    class DanhMucBanPhongData
    {
        sqlDataProvider sdp1 = new sqlDataProvider();
        sqlDataProvider sdp2 = new sqlDataProvider();
        public DataTable layDanhSachPhong()
        {
            SqlCommand cmd = new SqlCommand("Select TenPhong from Phong");
            sdp1.Load(cmd);
            return sdp1;
        }
        public DataTable layDanhSachBan()
        {
            SqlCommand cmd = new SqlCommand("Select TenBan from Ban");
            sdp2.Load(cmd);
            return sdp2;
        }
    }
}
